package com.linlang.grasharepro.utils;


import com.linlang.grasharepro.dao.CollectionDB;
import com.linlang.grasharepro.dao.ExperienceDB;
import com.linlang.grasharepro.dao.FansDB;
import com.linlang.grasharepro.dao.FollowDB;
import com.linlang.grasharepro.dao.MyShareDB;
import com.linlang.grasharepro.dao.NewMessageDB;
import com.linlang.grasharepro.dao.ShareCoentenDB;
import com.linlang.grasharepro.dao.ShareMessageDB;
import com.linlang.grasharepro.dao.UserDB;

public class DataBaseConstant {

    //用户表
    public static final String CREATE_TABLE_USER =
            "CREATE TABLE if not exists " + UserDB.SQLITE_TABLE + " (" +
                    UserDB.PK + " integer PRIMARY KEY autoincrement," +
                    UserDB.LOGIN_NAME + "," +
                    UserDB.LOGIN_PASS + "," +
                    UserDB.ROLE + "," +
                    UserDB.MAJOR + "," +
                    UserDB.SCHOOL + "," +
                    UserDB.GRADUATION_TIME + "," +
                    UserDB.ACADEMIC_STARTS + "," +
                    UserDB.HEAD_URL + "," +
                    UserDB.DISPLAY_NAME + "," +
                    UserDB.SEX + "," +
                    UserDB.BIRTHDAY + "," +
                    UserDB.WORK + "," +
                    UserDB.LACATION + "," +
                    UserDB.CONTACTWAY + "," +
                    UserDB.REAL_NAME + "," +
                    UserDB.MAIL + "," +
                    UserDB.INTRODUCTION +
                    ");";

    //分享内容表
    public static final String CREATE_TABLE_SHARE_CONTEN =
            "CREATE TABLE if not exists " + ShareCoentenDB.SQLITE_TABLE + " (" +
                    ShareCoentenDB.PK + " integer PRIMARY KEY autoincrement," +
                    ShareCoentenDB.USER_NAME + "," +
                    ShareCoentenDB.COLLECTION_COUNT + "," +
                    ShareCoentenDB.CONTENT + "," +
                    ShareCoentenDB.HEAD_URL + "," +
                    ShareCoentenDB.MESSAGE_COUNT + "," +
                    ShareCoentenDB.SHARE_COUNT + "," +
                    ShareCoentenDB.TIME + "," +
                    ShareCoentenDB.TITLE + "," +
                    ShareCoentenDB.TYPE + "," +
                    ShareCoentenDB.MAJOR + "," +
                    ShareCoentenDB.IMG_URL + "," +
                    ShareCoentenDB.IMG_URL1 + "," +
                    ShareCoentenDB.IMG_URL2 + "," +
                    ShareCoentenDB.IMG_URL3 + "," +
                    ShareCoentenDB.IMG_URL4 + "," +
                    ShareCoentenDB.IMG_URL5 + "," +
                    ShareCoentenDB.IMG_URL6 + "," +
                    ShareCoentenDB.IMG_URL7 + "," +
                    ShareCoentenDB.IMG_URL8 + "," +
                    ShareCoentenDB.EXPERIENCE_ID +

                    ");";

    //留言表
    public static final String CREATE_TABLE_SHARE_MESSAGE = "CREATE TABLE if not exists " + ShareMessageDB.SQLITE_TABLE + " (" +
            ShareMessageDB.PK + " integer PRIMARY KEY autoincrement," +
            ShareMessageDB.USER_NAME + "," +
            ShareMessageDB.CONTENT + "," +
            ShareMessageDB.HEAD_URL + "," +
            ShareMessageDB.TIME + "," +
            ShareMessageDB.SHARE_COENTEN_ID + "," +
            ShareMessageDB.TYPE +
            ");";

    //消息表
    public static final String CREATE_TABLE_NEW_MESSAGE = "CREATE TABLE if not exists " + NewMessageDB.SQLITE_TABLE + " (" +
            NewMessageDB.PK + " integer PRIMARY KEY autoincrement," +
            NewMessageDB.FROM_USER + "," +
            NewMessageDB.TO_USER + "," +
            NewMessageDB.CONTENT + "," +
            NewMessageDB.TIME + "," +
            NewMessageDB.TYPE + "," +
            NewMessageDB.IMAGE + "," +
            NewMessageDB.FLAG +
            ");";

    //收藏表
    public static final String CREATE_TABLE_COLLECT = "CREATE TABLE if not exists " + CollectionDB.SQLITE_TABLE + " (" +
            CollectionDB.PK + " integer PRIMARY KEY autoincrement," +
            CollectionDB.USER_NAME + "," +
            CollectionDB.TIME + "," +
            CollectionDB.RELATION_ID +
            ");";

    //分享表
    public static final String CREATE_TABLE_MY_SHARE = "CREATE TABLE if not exists " + MyShareDB.SQLITE_TABLE + " (" +
            MyShareDB.PK + " integer PRIMARY KEY autoincrement," +
            MyShareDB.USER_NAME + "," +
            MyShareDB.TIME + "," +
            MyShareDB.RELATION_ID +
            ");";

    //关注表
    public static final String CREATE_TABLE_FOLLOW = "CREATE TABLE if not exists " + FollowDB.SQLITE_TABLE + " (" +
            FollowDB.PK + " integer PRIMARY KEY autoincrement," +
            FollowDB.USER_NAME + "," +
            FollowDB.TIME + "," +
            FollowDB.RELATION_ID +
            ");";

    //粉丝表
    public static final String CREATE_TABLE_FANS = "CREATE TABLE if not exists " + FansDB.SQLITE_TABLE + " (" +
            FansDB.PK + " integer PRIMARY KEY autoincrement," +
            FansDB.USER_NAME + "," +
            FansDB.TIME + "," +
            FansDB.RELATION_ID +
            ");";

    //经历名片表
    public static final String CREATE_TABLE_EXPERIENCE_CARD = "CREATE TABLE if not exists " + ExperienceDB.SQLITE_TABLE + " (" +
            ExperienceDB.PK + " integer PRIMARY KEY autoincrement," +
            ExperienceDB.GRADUATION_TIME + "," +
            ExperienceDB.COMPANY + "," +
            ExperienceDB.POSITION + "," +
            ExperienceDB.CONTENT + "," +
            ExperienceDB.TREATMENT + "," +
            ExperienceDB.EXPERINCE + "," +
            ExperienceDB.DIFFERENT + "," +
            ExperienceDB.IS_RECRUIT + "," +
            ExperienceDB.RELATION + "," +
            ExperienceDB.RELATION_WAY +
            ");";
}